Data Settings - Load/Save

Exporting OP reserves and schedule data to Excel

Data Settings - Load/Save

To access this dialog:

  • Activate the Reserves ribbon and select Mining Blocks | Evaluate. Select the Report Settings tab.

  • Using the Scheduler ribbon, select Data Settings and select the Report tab.

The functions on this panel can be used to export your current data to Microsoft Excel, and automatically apply a template to format the data into a more accessible form.

If a template file is not specified, or does not exist, data will still be exported to Excel and can be manually formatted afterwards. Please note that Datamine do not support any of the functions offered by the Microsoft Office suite of products.

Field Details:

Template File: enter the path and name of an Excel file (.xls, .xlsx or .xlst). This template file will be applied by Excel to the specified Report File.

Report File: enter the path and name of the Excel file that will be generated and (optionally) formatted by a separate Template File.

Sheet Name: if you want to generate a worksheet in the specified Report File with a specific name, enter it here.

Start Range: enter the cell at which data will be generated. Data will subsequently be generated in a left-right and top-bottom order.

Clear Sheet: if enabled, any existing sheet matching the above details will be cleared before new data is added, otherwise data will not be cleared first.

   openbook.gif (910 bytes)    Related Topics

 

About Data SettingsData Settings: Select DataData Settings: Field TreatmentsData Settings: Options